// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_SYS_FILE
// * CreateDate    : 2014-06-05 18:30:43
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:43
// * LastChanger   : 2014-06-05 18:30:43
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class SysFileTable : TableInfo
    {
		public const string C_TableName = "SYS_FILE";

        public const string C_ID = "ID";
        public const string C_IS_ACTIVE = "IS_ACTIVE";
        public const string C_CREATED_DATE = "CREATED_DATE";
        public const string C_CREATED_BY = "CREATED_BY";
        public const string C_UPDATED_DATE = "UPDATED_DATE";
        public const string C_UPDATED_BY = "UPDATED_BY";
        public const string C_FORM_NAME = "FORM_NAME";
        public const string C_ROW_ID = "ROW_ID";
        public const string C_NAME = "NAME";
        public const string C_PATH = "PATH";
        public const string C_TYPE = "TYPE";
        public const string C_DEPT_NO = "DEPT_NO";
        public const string C_DOCUMENT_NO = "DOCUMENT_NO";
        public const string C_FILE_NO = "FILE_NO";
        public const string C_ACTIVE_DATE = "ACTIVE_DATE";
        public const string C_INACTIVE_DATE = "INACTIVE_DATE";
        public const string C_VER = "VER";
        public const string C_CONTROL_TYPE = "CONTROL_TYPE";
        public const string C_FILE_EXISTS_TYPE = "FILE_EXISTS_TYPE";
        public const string C_SAVE_TIMERANGE = "SAVE_TIMERANGE";
        public const string C_FILE_POSITION = "FILE_POSITION";
        public const string C_FILE_STATUS = "FILE_STATUS";
        public const string C_LOGIC_NO = "LOGIC_NO";
		
		public SysFileTable()
        {
            _tableName = "SYS_FILE";
        }
		
		protected static SysFileTable _current;
        public static SysFileTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new SysFileTable();

            _current.Add(C_ID, new ColumnInfo(C_ID, "Id", true, typeof(string)));
            _current.Add(C_IS_ACTIVE, new ColumnInfo(C_IS_ACTIVE, "IsActive", false, typeof(int)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE, "CreatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY, "CreatedBy", false, typeof(string)));
            _current.Add(C_UPDATED_DATE, new ColumnInfo(C_UPDATED_DATE, "UpdatedDate", false, typeof(DateTime)));
            _current.Add(C_UPDATED_BY, new ColumnInfo(C_UPDATED_BY, "UpdatedBy", false, typeof(string)));
            _current.Add(C_FORM_NAME, new ColumnInfo(C_FORM_NAME, "FormName", false, typeof(string)));
            _current.Add(C_ROW_ID, new ColumnInfo(C_ROW_ID, "RowId", false, typeof(string)));
            _current.Add(C_NAME, new ColumnInfo(C_NAME, "Name", false, typeof(string)));
            _current.Add(C_PATH, new ColumnInfo(C_PATH, "Path", false, typeof(string)));
            _current.Add(C_TYPE, new ColumnInfo(C_TYPE, "Type", false, typeof(string)));
            _current.Add(C_DEPT_NO, new ColumnInfo(C_DEPT_NO, "DeptNo", false, typeof(string)));
            _current.Add(C_DOCUMENT_NO, new ColumnInfo(C_DOCUMENT_NO, "DocumentNo", false, typeof(string)));
            _current.Add(C_FILE_NO, new ColumnInfo(C_FILE_NO, "FileNo", false, typeof(string)));
            _current.Add(C_ACTIVE_DATE, new ColumnInfo(C_ACTIVE_DATE, "ActiveDate", false, typeof(DateTime)));
            _current.Add(C_INACTIVE_DATE, new ColumnInfo(C_INACTIVE_DATE, "InactiveDate", false, typeof(DateTime)));
            _current.Add(C_VER, new ColumnInfo(C_VER, "Ver", false, typeof(string)));
            _current.Add(C_CONTROL_TYPE, new ColumnInfo(C_CONTROL_TYPE, "ControlType", false, typeof(string)));
            _current.Add(C_FILE_EXISTS_TYPE, new ColumnInfo(C_FILE_EXISTS_TYPE, "FileExistsType", false, typeof(string)));
            _current.Add(C_SAVE_TIMERANGE, new ColumnInfo(C_SAVE_TIMERANGE, "SaveTimerange", false, typeof(string)));
            _current.Add(C_FILE_POSITION, new ColumnInfo(C_FILE_POSITION, "FilePosition", false, typeof(string)));
            _current.Add(C_FILE_STATUS, new ColumnInfo(C_FILE_STATUS, "FileStatus", false, typeof(string)));
            _current.Add(C_LOGIC_NO, new ColumnInfo(C_LOGIC_NO, "LogicNo", false, typeof(string)));
			
		}

        public ColumnInfo ID
        {
            get { return this[C_ID]; }
        }

        public ColumnInfo IS_ACTIVE
        {
            get { return this[C_IS_ACTIVE]; }
        }

        public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }

        public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }

        public ColumnInfo UPDATED_DATE
        {
            get { return this[C_UPDATED_DATE]; }
        }

        public ColumnInfo UPDATED_BY
        {
            get { return this[C_UPDATED_BY]; }
        }

        public ColumnInfo FORM_NAME
        {
            get { return this[C_FORM_NAME]; }
        }

        public ColumnInfo ROW_ID
        {
            get { return this[C_ROW_ID]; }
        }

        public ColumnInfo NAME
        {
            get { return this[C_NAME]; }
        }

        public ColumnInfo PATH
        {
            get { return this[C_PATH]; }
        }

        public ColumnInfo TYPE
        {
            get { return this[C_TYPE]; }
        }

        public ColumnInfo DEPT_NO
        {
            get { return this[C_DEPT_NO]; }
        }

        public ColumnInfo DOCUMENT_NO
        {
            get { return this[C_DOCUMENT_NO]; }
        }

        public ColumnInfo FILE_NO
        {
            get { return this[C_FILE_NO]; }
        }

        public ColumnInfo ACTIVE_DATE
        {
            get { return this[C_ACTIVE_DATE]; }
        }

        public ColumnInfo INACTIVE_DATE
        {
            get { return this[C_INACTIVE_DATE]; }
        }

        public ColumnInfo VER
        {
            get { return this[C_VER]; }
        }

        public ColumnInfo CONTROL_TYPE
        {
            get { return this[C_CONTROL_TYPE]; }
        }

        public ColumnInfo FILE_EXISTS_TYPE
        {
            get { return this[C_FILE_EXISTS_TYPE]; }
        }

        public ColumnInfo SAVE_TIMERANGE
        {
            get { return this[C_SAVE_TIMERANGE]; }
        }

        public ColumnInfo FILE_POSITION
        {
            get { return this[C_FILE_POSITION]; }
        }

        public ColumnInfo FILE_STATUS
        {
            get { return this[C_FILE_STATUS]; }
        }

        public ColumnInfo LOGIC_NO
        {
            get { return this[C_LOGIC_NO]; }
        }
		
		
	}
}

